From 744945abfc9936ead820f992887bfe77067d138e Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Wed, 5 Aug 2026 15:51:41 +0000
Subject: [PATCH] Add example query to GROOM_SCANS_B doc

---
 doc/src/tables/groom_scans_b.m4 | 32 ++++++++++++++++++++++++++++----
 1 file changed, 28 insertions(+), 4 deletions(-)

diff --git a/doc/src/tables/groom_scans_b.m4 b/doc/src/tables/groom_scans_b.m4
index e0d4da4..f7dc8d3 100644
--- a/doc/src/tables/groom_scans_b.m4
+++ b/doc/src/tables/groom_scans_b.m4
@@ -33,10 +33,6 @@ GROOM_SCANS_B
 
 |GROOM_SCANS_B_summary|
 
-.. sidebar::
-
-   |DYADS helpful|
-
 In this data set, all groomings observed in periodic 5 minute
 intervals were recorded.
 
@@ -63,6 +59,34 @@ For further information, including additional data integrity rules,
 see the documentation of the :ref:`EVENTS <EVENTS_groom_scan_code>`
 table.
 
+The |DYADS| view is useful when querying GROOM_SCANS_B.
+
+.. code-block:: sql
+   :caption:
+      Using DYADS to provide a more complete picture of B-Record
+      groom scans
+
+   SELECT dyads.wid, dyads.type
+        , dyads.eid
+        , dyads.actor_pid, dyads.recipient_pid
+        , dyads.date
+        , dyads.animid AS focal
+        , dyads.commid
+        , dyads.start AS time
+        , dyads.actor, dyads.recipient
+        , dyads.style
+        , groom_scans_b.others
+        , groom_scans_b.extractedby
+        , dyads.notes
+        , dyads.event_notes
+        , groom_scans_b.duplicate
+     FROM dyads
+       JOIN groom_scans_b
+            ON (groom_scans_b.eid = dyads.eid)
+     WHERE dyads.behavior = 'sdb_groom_scan'
+     ORDER BY dyads.actor, dyads.date, dyads.start
+            , dyads.recipient, dyads.eid;
+
 
 .. contents::
    :depth: 2
-- 
2.34.1